package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the MM_MATMAS_INB database table.
 * 
 */
@Entity
@Table(name="MM_MATMAS_INB")
@NamedQueries({
    @NamedQuery(name = "MmMatmasInb.findAll", query = " SELECT c FROM MmMatmasInb c "),
    @NamedQuery(name = "MmMatmasInb.findAllIsSync", query = " SELECT c FROM MmMatmasInb c Where c.issync = :issync Order by c.instanceNo asc"),
    @NamedQuery(name = "MmMatmasInb.findById", query = " SELECT c FROM MmMatmasInb c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "MmMatmasInb.findByInstanceNo", query = " SELECT c FROM MmMatmasInb c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.articleCode,c.promisStagingId asc")
    })
public class MmMatmasInb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ARTI_GRP_CODE", nullable=false, length=30)
	private String artiGrpCode;

	@Column(name="ARTI_GRP_NAME", nullable=false, length=250)
	private String artiGrpName;

	@Column(name="ARTI_SUB_GRP_CODE", nullable=false, length=30)
	private String artiSubGrpCode;

	@Column(name="ARTI_SUB_GRP_NAME", nullable=false, length=250)
	private String artiSubGrpName;

	@Column(name="ARTI_TYPE_CODE", nullable=false, length=1)
	private String artiTypeCode;

	@Column(name="ARTI_TYPE_NAME", nullable=false, length=250)
	private String artiTypeName;

	@Column(name="ARTICLE_CODE", nullable=false, length=30)
	private String articleCode;

	@Column(name="COMPANY_CODE", nullable=false, length=4)
	private String companyCode;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(nullable=false, length=300)
	private String description;

	@Column(name="DESCRIPTION_TH", nullable=false, length=300)
	private String descriptionTh;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(name="ITEM_TYPE", nullable=false, length=2)
	private String itemType;

	@Column(nullable=false, precision=3)
	private BigDecimal leadtime;

	@Column(name="MSG_ACT_RESULT", length=100)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=300)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=100)
	private String msgCode;

	@Column(name="MSG_DESC", length=300)
	private String msgDesc;

	@Column(name="PR_FLAG", nullable=false, length=1)
	private String prFlag;

	@Column(name="PROJECT_CODE", nullable=false, length=30)
	private String projectCode;

	@Column(name="SEQ_NO", nullable=false, precision=3)
	private BigDecimal seqNo;

	@Column(nullable=false, length=1)
	private String status;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(nullable=false, length=30)
	private String um;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;
	
	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandle;
	
	@Column(name="PRODUCT_TYPE", length=100)
	private String productType;
	
	@Column(name="PRODUCT_CODE", length=150)
	private String productCode;
	
	@Column(name="MODEL_CODE", length=150)
	private String modelCode;
	
	@Column(name="BRAND_NAME", length=300)
	private String brandName;
	
	@Column(name="MATERIAL_TYPE", length=250)
	private String materialType;
	
	@Column(name="PRODUCT_COLOR", length=250)
	private String productColor;
	
	@Column(name="PRODUCT_SIZE", length=250)
	private String productSize;
	
	@Column(name="INSTALL_LOCATION", length=300)
	private String installlocation;
	
	@Column(name="PRODUCT_DETAILS", length=500)
	private String productdetail;

	@Column(name="MANUFACTURES", length=300)
	private String manufactures;
	
	@Column(name="PICTURE_PATH", length=300)
	private String picturepath;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;
	
	@Column(name="SAP_COMPANY_CODE", length=100)
	private String sapCompanyCode;	
	
	@Column(name="SAP_PLANT_CODE", length=100)
	private String sapPlantCode;
	
    public String getSapCompanyCode() {
		return sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

    /**
	 * @return the brandName
	 */
	public String getBrandName() {
		return brandName;
	}

	/**
	 * @param brandName the brandName to set
	 */
	public void setBrandName(String brandName) {
		this.brandName = brandName;
	}

	/**
	 * @return the productType
	 */
	public String getProductType() {
		return productType;
	}

	/**
	 * @param productType the productType to set
	 */
	public void setProductType(String productType) {
		this.productType = productType;
	}

	/**
	 * @return the productCode
	 */
	public String getProductCode() {
		return productCode;
	}

	/**
	 * @param productCode the productCode to set
	 */
	public void setProductCode(String productCode) {
		this.productCode = productCode;
	}

	/**
	 * @return the modelCode
	 */
	public String getModelCode() {
		return modelCode;
	}

	/**
	 * @param modelCode the modelCode to set
	 */
	public void setModelCode(String modelCode) {
		this.modelCode = modelCode;
	}

	/**
	 * @return the materialType
	 */
	public String getMaterialType() {
		return materialType;
	}

	/**
	 * @param materialType the materialType to set
	 */
	public void setMaterialType(String materialType) {
		this.materialType = materialType;
	}

	/**
	 * @return the productColor
	 */
	public String getProductColor() {
		return productColor;
	}

	/**
	 * @param productColor the productColor to set
	 */
	public void setProductColor(String productColor) {
		this.productColor = productColor;
	}

	/**
	 * @return the productSize
	 */
	public String getProductSize() {
		return productSize;
	}

	/**
	 * @param productSize the productSize to set
	 */
	public void setProductSize(String productSize) {
		this.productSize = productSize;
	}

	/**
	 * @return the installlocation
	 */
	public String getInstalllocation() {
		return installlocation;
	}

	/**
	 * @param installlocation the installlocation to set
	 */
	public void setInstalllocation(String installlocation) {
		this.installlocation = installlocation;
	}

	/**
	 * @return the productdetail
	 */
	public String getProductdetail() {
		return productdetail;
	}

	/**
	 * @param productdetail the productdetail to set
	 */
	public void setProductdetail(String productdetail) {
		this.productdetail = productdetail;
	}

	/**
	 * @return the manufactures
	 */
	public String getManufactures() {
		return manufactures;
	}

	/**
	 * @param manufactures the manufactures to set
	 */
	public void setManufactures(String manufactures) {
		this.manufactures = manufactures;
	}

	/**
	 * @return the picturepath
	 */
	public String getPicturepath() {
		return picturepath;
	}

	/**
	 * @param picturepath the picturepath to set
	 */
	public void setPicturepath(String picturepath) {
		this.picturepath = picturepath;
	}

	/**
	 * @return the actionHandle
	 */
	public String getActionHandle() {
		return actionHandle;
	}

	/**
	 * @param actionHandle the actionHandle to set
	 */
	public void setActionHandle(String actionHandle) {
		this.actionHandle = actionHandle;
	}

	public MmMatmasInb() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getArtiGrpCode() {
		return this.artiGrpCode;
	}

	public void setArtiGrpCode(String artiGrpCode) {
		this.artiGrpCode = artiGrpCode;
	}

	public String getArtiGrpName() {
		return this.artiGrpName;
	}

	public void setArtiGrpName(String artiGrpName) {
		this.artiGrpName = artiGrpName;
	}

	public String getArtiSubGrpCode() {
		return this.artiSubGrpCode;
	}

	public void setArtiSubGrpCode(String artiSubGrpCode) {
		this.artiSubGrpCode = artiSubGrpCode;
	}

	public String getArtiSubGrpName() {
		return this.artiSubGrpName;
	}

	public void setArtiSubGrpName(String artiSubGrpName) {
		this.artiSubGrpName = artiSubGrpName;
	}

	public String getArtiTypeCode() {
		return this.artiTypeCode;
	}

	public void setArtiTypeCode(String artiTypeCode) {
		this.artiTypeCode = artiTypeCode;
	}

	public String getArtiTypeName() {
		return this.artiTypeName;
	}

	public void setArtiTypeName(String artiTypeName) {
		this.artiTypeName = artiTypeName;
	}

	public String getArticleCode() {
		return this.articleCode;
	}

	public void setArticleCode(String articleCode) {
		this.articleCode = articleCode;
	}

	public String getCompanyCode() {
		return this.companyCode;
	}

	public void setCompanyCode(String companyCode) {
		this.companyCode = companyCode;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getDescriptionTh() {
		return this.descriptionTh;
	}

	public void setDescriptionTh(String descriptionTh) {
		this.descriptionTh = descriptionTh;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getItemType() {
		return this.itemType;
	}

	public void setItemType(String itemType) {
		this.itemType = itemType;
	}

	public BigDecimal getLeadtime() {
		return this.leadtime;
	}

	public void setLeadtime(BigDecimal leadtime) {
		this.leadtime = leadtime;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPrFlag() {
		return this.prFlag;
	}

	public void setPrFlag(String prFlag) {
		this.prFlag = prFlag;
	}

	public String getProjectCode() {
		return this.projectCode;
	}

	public void setProjectCode(String projectCode) {
		this.projectCode = projectCode;
	}

	public BigDecimal getSeqNo() {
		return this.seqNo;
	}

	public void setSeqNo(BigDecimal seqNo) {
		this.seqNo = seqNo;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUm() {
		return this.um;
	}

	public void setUm(String um) {
		this.um = um;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}